ilr_ft_mapping

Table: ilr_ft_mapping

The ilr_ft_mapping table maps ILR units to FT (Fridge Tag) devices and monitoring activities.
It is used for tracking the association between ILRs, monitoring IDs, and FT devices for cold chain monitoring.

---

Columns

Column Name	Data Type	Constraints	Description
id	bigint(20)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique identifier for each mapping record
createdDate	datetime	NULL	Timestamp when the mapping was created
lastEditedDate	datetime	NULL	Timestamp when the mapping was last edited
ftid	bigint(20)	NULL	ID of the FT device (Fridge Tag)
ilrMonitoringId	bigint(20)	NULL	ID of the ILR monitoring activity
ilrid	bigint(20)	NULL	ID of the ILR unit
voided	tinyint(1)	NULL	Flag indicating if the mapping is voided (1 = voided, 0 = active)
createdByUserId	int(11)	NULL	ID of the user who created the mapping
lastEditedByUserId	int(11)	NULL	ID of the user who last edited the mapping

---

Indexes

1. PRIMARY - Primary key on id

---

Foreign Key Relations

• No explicit foreign keys are defined, but typically:
  • ftid references a fridge tag device (fridgetag or fridgetaginfo)
  • ilrMonitoringId references ilrmonitoring.id
  • ilrid references ilr.id
  • createdByUserId and lastEditedByUserId reference user IDs for audit tracking

---

Usage Notes

• Used to track which FT devices are associated with which ILR units and monitoring events.
• voided field maintains integrity of historical mappings.
• Supports cold chain monitoring by linking physical devices to ILR units and their monitoring activities.
• createdByUserId and lastEditedByUserId provide an audit trail for mapping changes.